CREATE TABLE [dbo].[Orders_VAT]
(
[ORDER_NUMBER] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Orders_VAT_ORDER_NUMBER] DEFAULT ((0)),
[OVATRegNumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_VAT_OVATRegNumber] DEFAULT (''),
[OVATCountry] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_VAT_OVATCountry] DEFAULT (''),
[OVATBranchID] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_VAT_OVATBranchID] DEFAULT (''),
[OUseVATTaxation] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_VAT_OUseVATTaxation] DEFAULT (''),
[NTAX_AUTHOR_DEFAULT] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_VAT_NTAX_AUTHOR_DEFAULT] DEFAULT (''),
[NVAT_REG_NUMBER] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_VAT_NVAT_REG_NUMBER] DEFAULT (''),
[NVAT_COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Orders_VAT_NVAT_COUNTRY] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Orders_VAT] ADD CONSTRAINT [PK_Orders_VAT] PRIMARY KEY CLUSTERED ([ORDER_NUMBER]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Orders_VAT] TO [IMIS]
GRANT SELECT ON  [dbo].[Orders_VAT] TO [IMIS]
GRANT INSERT ON  [dbo].[Orders_VAT] TO [IMIS]
GRANT DELETE ON  [dbo].[Orders_VAT] TO [IMIS]
GRANT UPDATE ON  [dbo].[Orders_VAT] TO [IMIS]
GO